Overview

Brought to you by YData

Dataset statistics

Number of variables	26
Number of observations	1696234
Missing cells	10226144
Missing cells (%)	23.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.5 GiB
Average record size in memory	920.9 B

Variable types

Numeric	12
DateTime	3
Text	6
Categorical	5

Alerts

`Unnamed: 0` is highly overall correlated with `player_id`	High correlation
`competition_id` is highly overall correlated with `current_club_domestic_competition_id`	High correlation
`current_club_domestic_competition_id` is highly overall correlated with `competition_id`	High correlation
`current_club_id` is highly overall correlated with `player_club_id` and 1 other fields	High correlation
`highest_market_value_in_eur` is highly overall correlated with `market_value_in_eur`	High correlation
`last_season` is highly overall correlated with `market_value_in_eur`	High correlation
`market_value_in_eur` is highly overall correlated with `highest_market_value_in_eur` and 1 other fields	High correlation
`player_club_id` is highly overall correlated with `current_club_id` and 1 other fields	High correlation
`player_current_club_id` is highly overall correlated with `current_club_id` and 1 other fields	High correlation
`player_id` is highly overall correlated with `Unnamed: 0`	High correlation
`position` is highly overall correlated with `sub_position`	High correlation
`sub_position` is highly overall correlated with `position`	High correlation
`first_name` has 639134 (37.7%) missing values	Missing
`last_name` has 639134 (37.7%) missing values	Missing
`name` has 639134 (37.7%) missing values	Missing
`last_season` has 639134 (37.7%) missing values	Missing
`current_club_id` has 639134 (37.7%) missing values	Missing
`country_of_citizenship` has 639134 (37.7%) missing values	Missing
`date_of_birth` has 639134 (37.7%) missing values	Missing
`sub_position` has 639134 (37.7%) missing values	Missing
`position` has 639134 (37.7%) missing values	Missing
`foot` has 639134 (37.7%) missing values	Missing
`height_in_cm` has 639134 (37.7%) missing values	Missing
`contract_expiration_date` has 639134 (37.7%) missing values	Missing
`current_club_domestic_competition_id` has 639134 (37.7%) missing values	Missing
`current_club_name` has 639134 (37.7%) missing values	Missing
`market_value_in_eur` has 639134 (37.7%) missing values	Missing
`highest_market_value_in_eur` has 639134 (37.7%) missing values	Missing
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`goals` has 1550716 (91.4%) zeros	Zeros
`assists` has 1577530 (93.0%) zeros	Zeros

Reproduction

Analysis started	2025-03-12 19:11:15.317045
Analysis finished	2025-03-12 19:12:28.640726
Duration	1 minute and 13.32 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

High correlation Uniform Unique

Distinct	1696234
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	848116.5

Minimum	0
Maximum	1696233
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	84811.65
Q1	424058.25
median	848116.5
Q3	1272174.8
95-th percentile	1611421.3
Maximum	1696233
Range	1696233
Interquartile range (IQR)	848116.5

Descriptive statistics

Standard deviation	489660.72
Coefficient of variation (CV)	0.57735078
Kurtosis	-1.2
Mean	848116.5
Median Absolute Deviation (MAD)	424058.5
Skewness	-3.935866 × 10^-15
Sum	1.438604 × 10¹²
Variance	2.3976762 × 10¹¹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
1130818	1	< 0.1%
1130828	1	< 0.1%
1130827	1	< 0.1%
1130826	1	< 0.1%
1130825	1	< 0.1%
1130824	1	< 0.1%
1130823	1	< 0.1%
1130822	1	< 0.1%
1130821	1	< 0.1%
Other values (1696224)	1696224	> 99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
1696233	1	< 0.1%
1696232	1	< 0.1%
1696231	1	< 0.1%
1696230	1	< 0.1%
1696229	1	< 0.1%
1696228	1	< 0.1%
1696227	1	< 0.1%
1696226	1	< 0.1%
1696225	1	< 0.1%
1696224	1	< 0.1%

player_id
Real number (ℝ)

High correlation

Distinct	25661
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	208378.44

Minimum	10
Maximum	1380876
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	10
5-th percentile	15452
Q1	58252
median	148396
Q3	300168
95-th percentile	603149
Maximum	1380876
Range	1380866
Interquartile range (IQR)	241916

Descriptive statistics

Standard deviation	192896.91
Coefficient of variation (CV)	0.92570471
Kurtosis	2.1678484
Mean	208378.44
Median Absolute Deviation (MAD)	103452
Skewness	1.4389208
Sum	3.534586 × 10¹¹
Variance	3.7209217 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38253	605	< 0.1%
32467	578	< 0.1%
59561	563	< 0.1%
125781	563	< 0.1%
74229	560	< 0.1%
36139	558	< 0.1%
28396	558	< 0.1%
56416	551	< 0.1%
91845	549	< 0.1%
65278	545	< 0.1%
Other values (25651)	1690604	99.7%

Value	Count	Frequency (%)
10	136	< 0.1%
26	152	< 0.1%
65	122	< 0.1%
77	4	< 0.1%
80	12	< 0.1%
109	41	< 0.1%
123	7	< 0.1%
132	77	< 0.1%
215	109	< 0.1%
258	19	< 0.1%

Value	Count	Frequency (%)
1380876	1	< 0.1%
1378362	1	< 0.1%
1358447	1	< 0.1%
1310513	3	< 0.1%
1309326	3	< 0.1%
1306851	8	< 0.1%
1302421	5	< 0.1%
1294052	11	< 0.1%
1294049	5	< 0.1%
1294048	2	< 0.1%

player_club_id
Real number (ℝ)

High correlation

Distinct	1064
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3124.6329

Minimum	1
Maximum	116786
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	1
5-th percentile	27
Q1	289
median	826
Q3	2441
95-th percentile	16239
Maximum	116786
Range	116785
Interquartile range (IQR)	2152

Descriptive statistics

Standard deviation	8249.8953
Coefficient of variation (CV)	2.6402767
Kurtosis	37.534735
Mean	3124.6329
Median Absolute Deviation (MAD)	626
Skewness	5.5674082
Sum	5.3001085 × 10⁹
Variance	68060772
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
418	10257	0.6%
131	10166	0.6%
368	9983	0.6%
506	9644	0.6%
985	9631	0.6%
281	9571	0.6%
631	9554	0.6%
31	9443	0.6%
371	9358	0.6%
27	9324	0.5%
Other values (1054)	1599303	94.3%

Value	Count	Frequency (%)
1	3	< 0.1%
2	13	< 0.1%
3	4896	0.3%
4	1501	0.1%
5	8964	0.5%
6	467	< 0.1%
9	4	< 0.1%
10	1087	0.1%
11	9290	0.5%
12	9022	0.5%

Value	Count	Frequency (%)
116786	2	< 0.1%
110302	361	< 0.1%
101634	1	< 0.1%
101362	3	< 0.1%
99200	2	< 0.1%
91328	3	< 0.1%
87883	1	< 0.1%
86209	285	< 0.1%
85465	327	< 0.1%
83678	445	< 0.1%

player_current_club_id
Real number (ℝ)

High correlation

Distinct	437
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3979.6011

Minimum	3
Maximum	110302
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	3
5-th percentile	29
Q1	331
median	903
Q3	2696
95-th percentile	19771
Maximum	110302
Range	110299
Interquartile range (IQR)	2365

Descriptive statistics

Standard deviation	10806.848
Coefficient of variation (CV)	2.7155607
Kurtosis	30.513812
Mean	3979.6011
Median Absolute Deviation (MAD)	713
Skewness	5.100011
Sum	6.7503347 × 10⁹
Variance	1.1678797 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36	11702	0.7%
683	10785	0.6%
1091	10266	0.6%
150	10255	0.6%
46	10109	0.6%
141	10108	0.6%
13	9981	0.6%
2381	9958	0.6%
368	9628	0.6%
589	9498	0.6%
Other values (427)	1593944	94.0%

Value	Count	Frequency (%)
3	4765	0.3%
4	987	0.1%
5	8638	0.5%
6	618	< 0.1%
10	1190	0.1%
11	7593	0.4%
12	8008	0.5%
13	9981	0.6%
15	7461	0.4%
16	6481	0.4%

Value	Count	Frequency (%)
110302	2320	0.1%
86209	729	< 0.1%
85465	1892	0.1%
83678	769	< 0.1%
75231	824	< 0.1%
71985	1222	0.1%
68608	1977	0.1%
63007	2555	0.2%
61825	2392	0.1%
60949	4824	0.3%

date
Date

Distinct	3717
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	12.9 MiB

Minimum	2012-07-03 00:00:00
Maximum	2025-03-10 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

player_name
Text

Distinct	25119
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	126.2 MiB

Length

Max length	32
Median length	29
Mean length	13.473428
Min length	2

Characters and Unicode

Total characters	22854086
Distinct characters	121
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2111 ?
Unique (%)	0.1%

Sample

1st row	Aurélien Joachim
2nd row	Ruslan Abyshov
3rd row	Sander Puri
4th row	Vegar Hedenstad
5th row	Markus Henriksen

Value	Count	Frequency (%)
de	14398	0.4%
van	14237	0.4%
david	11680	0.3%
lucas	9957	0.3%
thomas	8444	0.3%
kevin	7908	0.2%
daniel	7764	0.2%
andré	7245	0.2%
pedro	7121	0.2%
joão	7084	0.2%
Other values (23832)	3280994	97.2%

Most occurring characters

Value	Count	Frequency (%)
a	2268340	9.9%
e	1733616	7.6%
	1680598	7.4%
i	1628621	7.1%
o	1530209	6.7%
n	1496563	6.5%
r	1419771	6.2%
l	991297	4.3%
s	990515	4.3%
t	678702	3.0%
Other values (111)	8435854	36.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	22854086	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2268340	9.9%
e	1733616	7.6%
	1680598	7.4%
i	1628621	7.1%
o	1530209	6.7%
n	1496563	6.5%
r	1419771	6.2%
l	991297	4.3%
s	990515	4.3%
t	678702	3.0%
Other values (111)	8435854	36.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	22854086	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2268340	9.9%
e	1733616	7.6%
	1680598	7.4%
i	1628621	7.1%
o	1530209	6.7%
n	1496563	6.5%
r	1419771	6.2%
l	991297	4.3%
s	990515	4.3%
t	678702	3.0%
Other values (111)	8435854	36.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	22854086	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2268340	9.9%
e	1733616	7.6%
	1680598	7.4%
i	1628621	7.1%
o	1530209	6.7%
n	1496563	6.5%
r	1419771	6.2%
l	991297	4.3%
s	990515	4.3%
t	678702	3.0%
Other values (111)	8435854	36.9%

competition_id
Categorical

High correlation

Distinct	43
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	97.0 MiB

IT1	139849
ES1	138147
GB1	135091
FR1	131229
TR1	119614
Other values (38)	1032304

Length

Max length	4
Median length	3
Mean length	2.9325748
Min length	2

Characters and Unicode

Total characters	4974333
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CLQ
2nd row	ELQ
3rd row	ELQ
4th row	ELQ
5th row	ELQ

Common Values

Value	Count	Frequency (%)
IT1	139849	8.2%
ES1	138147	8.1%
GB1	135091	8.0%
FR1	131229	7.7%
TR1	119614	7.1%
L1	112441	6.6%
NL1	107748	6.4%
PO1	107305	6.3%
BE1	92929	5.5%
RU1	85204	5.0%
Other values (33)	526677	31.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
it1	139849	8.2%
es1	138147	8.1%
gb1	135091	8.0%
fr1	131229	7.7%
tr1	119614	7.1%
l1	112441	6.6%
nl1	107748	6.4%
po1	107305	6.3%
be1	92929	5.5%
ru1	85204	5.0%
Other values (33)	526677	31.0%

Most occurring characters

Value	Count	Frequency (%)
1	1451827	29.2%
R	532295	10.7%
L	353586	7.1%
E	302983	6.1%
T	269688	5.4%
B	241271	4.9%
G	232914	4.7%
S	222972	4.5%
C	183736	3.7%
P	176424	3.5%
Other values (10)	1006637	20.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4974333	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	1451827	29.2%
R	532295	10.7%
L	353586	7.1%
E	302983	6.1%
T	269688	5.4%
B	241271	4.9%
G	232914	4.7%
S	222972	4.5%
C	183736	3.7%
P	176424	3.5%
Other values (10)	1006637	20.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4974333	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	1451827	29.2%
R	532295	10.7%
L	353586	7.1%
E	302983	6.1%
T	269688	5.4%
B	241271	4.9%
G	232914	4.7%
S	222972	4.5%
C	183736	3.7%
P	176424	3.5%
Other values (10)	1006637	20.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4974333	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	1451827	29.2%
R	532295	10.7%
L	353586	7.1%
E	302983	6.1%
T	269688	5.4%
B	241271	4.9%
G	232914	4.7%
S	222972	4.5%
C	183736	3.7%
P	176424	3.5%
Other values (10)	1006637	20.2%

goals
Real number (ℝ)

Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.095945489

Minimum	0
Maximum	6
Zeros	1550716
Zeros (%)	91.4%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.33104299
Coefficient of variation (CV)	3.4503236
Kurtosis	17.871832
Mean	0.095945489
Median Absolute Deviation (MAD)	0
Skewness	3.8743377
Sum	162746
Variance	0.10958946
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	1550716	91.4%
1	130219	7.7%
2	13566	0.8%
3	1562	0.1%
4	147	< 0.1%
5	23	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
0	1550716	91.4%
1	130219	7.7%
2	13566	0.8%
3	1562	0.1%
4	147	< 0.1%
5	23	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
6	1	< 0.1%
5	23	< 0.1%
4	147	< 0.1%
3	1562	0.1%
2	13566	0.8%
1	130219	7.7%
0	1550716	91.4%

assists
Real number (ℝ)

Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.075450085

Minimum	0
Maximum	6
Zeros	1577530
Zeros (%)	93.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.28542405
Coefficient of variation (CV)	3.782952
Kurtosis	18.381554
Mean	0.075450085
Median Absolute Deviation (MAD)	0
Skewness	4.0511294
Sum	127981
Variance	0.081466887
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	1577530	93.0%
1	110036	6.5%
2	8100	0.5%
3	530	< 0.1%
4	36	< 0.1%
5	1	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
0	1577530	93.0%
1	110036	6.5%
2	8100	0.5%
3	530	< 0.1%
4	36	< 0.1%
5	1	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
6	1	< 0.1%
5	1	< 0.1%
4	36	< 0.1%
3	530	< 0.1%
2	8100	0.5%
1	110036	6.5%
0	1577530	93.0%

minutes_played
Real number (ℝ)

Distinct	122
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.089002

Minimum	1
Maximum	148
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	45
median	90
Q3	90
95-th percentile	90
Maximum	148
Range	147
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	29.981585
Coefficient of variation (CV)	0.43395597
Kurtosis	-0.38137871
Mean	69.089002
Median Absolute Deviation (MAD)	0
Skewness	-1.0701778
Sum	1.1719112 × 10⁸
Variance	898.89546
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	907176	53.5%
45	66235	3.9%
1	26371	1.6%
78	11748	0.7%
12	11618	0.7%
76	11593	0.7%
77	11549	0.7%
14	11507	0.7%
75	11498	0.7%
74	11495	0.7%
Other values (112)	615444	36.3%

Value	Count	Frequency (%)
1	26371	1.6%
2	7796	0.5%
3	8545	0.5%
4	9092	0.5%
5	9663	0.6%
6	10271	0.6%
7	10756	0.6%
8	11084	0.7%
9	11253	0.7%
10	11241	0.7%

Value	Count	Frequency (%)
148	1	< 0.1%
135	2	< 0.1%
120	8142	0.5%
119	30	< 0.1%
118	30	< 0.1%
117	25	< 0.1%
116	21	< 0.1%
115	43	< 0.1%
114	28	< 0.1%
113	41	< 0.1%

first_name
Text

Missing

Distinct	4327
Distinct (%)	0.4%
Missing	639134
Missing (%)	37.7%
Memory size	86.0 MiB

Length

Max length	19
Median length	17
Mean length	5.8893984
Min length	2

Characters and Unicode

Total characters	6225683
Distinct characters	98
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	157 ?
Unique (%)	< 0.1%

Sample

1st row	Sander
2nd row	Vegar
3rd row	Markus
4th row	Peter
5th row	Dušan

Value	Count	Frequency (%)
david	6935	0.6%
lucas	6198	0.6%
kevin	5981	0.6%
thomas	5256	0.5%
marco	4859	0.5%
daniel	4815	0.5%
jordan	4376	0.4%
josé	4280	0.4%
ivan	4178	0.4%
aleksandr	4175	0.4%
Other values (4250)	1017562	95.2%

Most occurring characters

Value	Count	Frequency (%)
a	678099	10.9%
i	513525	8.2%
n	474548	7.6%
e	467321	7.5%
o	431505	6.9%
r	424406	6.8%
l	295512	4.7%
s	284348	4.6%
t	193573	3.1%
d	168892	2.7%
Other values (88)	2293954	36.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6225683	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	678099	10.9%
i	513525	8.2%
n	474548	7.6%
e	467321	7.5%
o	431505	6.9%
r	424406	6.8%
l	295512	4.7%
s	284348	4.6%
t	193573	3.1%
d	168892	2.7%
Other values (88)	2293954	36.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6225683	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	678099	10.9%
i	513525	8.2%
n	474548	7.6%
e	467321	7.5%
o	431505	6.9%
r	424406	6.8%
l	295512	4.7%
s	284348	4.6%
t	193573	3.1%
d	168892	2.7%
Other values (88)	2293954	36.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6225683	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	678099	10.9%
i	513525	8.2%
n	474548	7.6%
e	467321	7.5%
o	431505	6.9%
r	424406	6.8%
l	295512	4.7%
s	284348	4.6%
t	193573	3.1%
d	168892	2.7%
Other values (88)	2293954	36.8%

last_name
Text

Missing

Distinct	11003
Distinct (%)	1.0%
Missing	639134
Missing (%)	37.7%
Memory size	88.3 MiB

Length

Max length	22
Median length	19
Mean length	6.9684278
Min length	2

Characters and Unicode

Total characters	7366325
Distinct characters	105
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	624 ?
Unique (%)	0.1%

Sample

1st row	Puri
2nd row	Hedenstad
3rd row	Henriksen
4th row	Ankersen
5th row	Tadić

Value	Count	Frequency (%)
de	10214	0.9%
van	9376	0.9%
silva	3655	0.3%
garcía	3177	0.3%
el	3144	0.3%
martínez	2632	0.2%
fernandes	2440	0.2%
sánchez	2342	0.2%
costa	2310	0.2%
rodríguez	2242	0.2%
Other values (10996)	1053509	96.2%

Most occurring characters

Value	Count	Frequency (%)
a	798714	10.8%
e	636956	8.6%
i	520750	7.1%
o	510787	6.9%
r	480763	6.5%
n	475599	6.5%
s	355810	4.8%
l	341257	4.6%
t	238013	3.2%
u	234199	3.2%
Other values (95)	2773477	37.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7366325	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	798714	10.8%
e	636956	8.6%
i	520750	7.1%
o	510787	6.9%
r	480763	6.5%
n	475599	6.5%
s	355810	4.8%
l	341257	4.6%
t	238013	3.2%
u	234199	3.2%
Other values (95)	2773477	37.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7366325	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	798714	10.8%
e	636956	8.6%
i	520750	7.1%
o	510787	6.9%
r	480763	6.5%
n	475599	6.5%
s	355810	4.8%
l	341257	4.6%
t	238013	3.2%
u	234199	3.2%
Other values (95)	2773477	37.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7366325	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	798714	10.8%
e	636956	8.6%
i	520750	7.1%
o	510787	6.9%
r	480763	6.5%
n	475599	6.5%
s	355810	4.8%
l	341257	4.6%
t	238013	3.2%
u	234199	3.2%
Other values (95)	2773477	37.7%

name
Text

Missing

Distinct	13737
Distinct (%)	1.3%
Missing	639134
Missing (%)	37.7%
Memory size	99.0 MiB

Length

Max length	31
Median length	27
Mean length	13.857826
Min length	6

Characters and Unicode

Total characters	14649108
Distinct characters	112
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	882 ?
Unique (%)	0.1%

Sample

1st row	Sander Puri
2nd row	Vegar Hedenstad
3rd row	Markus Henriksen
4th row	Peter Ankersen
5th row	Dušan Tadić

Value	Count	Frequency (%)
de	10214	0.5%
van	9376	0.4%
david	7246	0.3%
lucas	6251	0.3%
thomas	6055	0.3%
kevin	5981	0.3%
marco	4860	0.2%
andré	4860	0.2%
daniel	4815	0.2%
jordan	4376	0.2%
Other values (14868)	2099622	97.0%

Most occurring characters

Value	Count	Frequency (%)
a	1476813	10.1%
	1106556	7.6%
e	1104277	7.5%
i	1034275	7.1%
n	950147	6.5%
o	942292	6.4%
r	905169	6.2%
s	640158	4.4%
l	636769	4.3%
t	431586	2.9%
Other values (102)	5421066	37.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	14649108	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1476813	10.1%
	1106556	7.6%
e	1104277	7.5%
i	1034275	7.1%
n	950147	6.5%
o	942292	6.4%
r	905169	6.2%
s	640158	4.4%
l	636769	4.3%
t	431586	2.9%
Other values (102)	5421066	37.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	14649108	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1476813	10.1%
	1106556	7.6%
e	1104277	7.5%
i	1034275	7.1%
n	950147	6.5%
o	942292	6.4%
r	905169	6.2%
s	640158	4.4%
l	636769	4.3%
t	431586	2.9%
Other values (102)	5421066	37.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	14649108	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1476813	10.1%
	1106556	7.6%
e	1104277	7.5%
i	1034275	7.1%
n	950147	6.5%
o	942292	6.4%
r	905169	6.2%
s	640158	4.4%
l	636769	4.3%
t	431586	2.9%
Other values (102)	5421066	37.0%

last_season
Real number (ℝ)

High correlation Missing

Distinct	13
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Infinite	0
Infinite (%)	0.0%
Mean	2022.5416

Minimum	2012
Maximum	2024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	2012
5-th percentile	2017
Q1	2022
median	2024
Q3	2024
95-th percentile	2024
Maximum	2024
Range	12
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.3321668
Coefficient of variation (CV)	0.0011530872
Kurtosis	3.0969526
Mean	2022.5416
Median Absolute Deviation (MAD)	0
Skewness	-1.8648831
Sum	2.1380287 × 10⁹
Variance	5.4390021
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
2024	602267	35.5%
2023	136924	8.1%
2021	74743	4.4%
2022	67704	4.0%
2020	55313	3.3%
2019	34412	2.0%
2018	28504	1.7%
2017	19381	1.1%
2016	14696	0.9%
2015	10815	0.6%
Other values (3)	12341	0.7%
(Missing)	639134	37.7%

Value	Count	Frequency (%)
2012	1489	0.1%
2013	3820	0.2%
2014	7032	0.4%
2015	10815	0.6%
2016	14696	0.9%
2017	19381	1.1%
2018	28504	1.7%
2019	34412	2.0%
2020	55313	3.3%
2021	74743	4.4%

Value	Count	Frequency (%)
2024	602267	35.5%
2023	136924	8.1%
2022	67704	4.0%
2021	74743	4.4%
2020	55313	3.3%
2019	34412	2.0%
2018	28504	1.7%
2017	19381	1.1%
2016	14696	0.9%
2015	10815	0.6%

current_club_id
Real number (ℝ)

High correlation Missing

Distinct	436
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Infinite	0
Infinite (%)	0.0%
Mean	3957.3817

Minimum	3
Maximum	110302
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	3
5-th percentile	27
Q1	281
median	800
Q3	2503
95-th percentile	18303
Maximum	110302
Range	110299
Interquartile range (IQR)	2222

Descriptive statistics

Standard deviation	11236.602
Coefficient of variation (CV)	2.8394031
Kurtosis	30.242986
Mean	3957.3817
Median Absolute Deviation (MAD)	620
Skewness	5.1230434
Sum	4.1833482 × 10⁹
Variance	1.2626122 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
46	7890	0.5%
36	7821	0.5%
141	7764	0.5%
13	7410	0.4%
27	7106	0.4%
244	6984	0.4%
2441	6948	0.4%
800	6749	0.4%
1091	6735	0.4%
418	6664	0.4%
Other values (426)	985029	58.1%
(Missing)	639134	37.7%

Value	Count	Frequency (%)
3	3396	0.2%
4	588	< 0.1%
5	5758	0.3%
6	207	< 0.1%
10	869	0.1%
11	5284	0.3%
12	6120	0.4%
13	7410	0.4%
15	5583	0.3%
16	5542	0.3%

Value	Count	Frequency (%)
110302	1651	0.1%
86209	703	< 0.1%
85465	1860	0.1%
83678	547	< 0.1%
75231	819	< 0.1%
71985	1154	0.1%
68608	282	< 0.1%
63007	2080	0.1%
61825	1200	0.1%
60949	3456	0.2%

country_of_citizenship
Text

Missing

Distinct	160
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Memory size	85.2 MiB

Length

Max length	24
Median length	21
Mean length	7.2155737
Min length	4

Characters and Unicode

Total characters	7627583
Distinct characters	56
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Estonia
2nd row	Norway
3rd row	Norway
4th row	Denmark
5th row	Serbia

Value	Count	Frequency (%)
spain	87042	7.9%
france	68495	6.2%
netherlands	57445	5.2%
england	50233	4.5%
germany	48818	4.4%
italy	46588	4.2%
portugal	41153	3.7%
russia	40992	3.7%
ukraine	39810	3.6%
belgium	38615	3.5%
Other values (177)	588458	53.1%

Most occurring characters

Value	Count	Frequency (%)
a	967578	12.7%
e	771955	10.1%
n	710105	9.3%
r	610939	8.0%
i	494101	6.5%
l	394209	5.2%
o	296412	3.9%
t	289315	3.8%
g	233037	3.1%
u	224036	2.9%
Other values (46)	2635896	34.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7627583	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	967578	12.7%
e	771955	10.1%
n	710105	9.3%
r	610939	8.0%
i	494101	6.5%
l	394209	5.2%
o	296412	3.9%
t	289315	3.8%
g	233037	3.1%
u	224036	2.9%
Other values (46)	2635896	34.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7627583	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	967578	12.7%
e	771955	10.1%
n	710105	9.3%
r	610939	8.0%
i	494101	6.5%
l	394209	5.2%
o	296412	3.9%
t	289315	3.8%
g	233037	3.1%
u	224036	2.9%
Other values (46)	2635896	34.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7627583	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	967578	12.7%
e	771955	10.1%
n	710105	9.3%
r	610939	8.0%
i	494101	6.5%
l	394209	5.2%
o	296412	3.9%
t	289315	3.8%
g	233037	3.1%
u	224036	2.9%
Other values (46)	2635896	34.6%

date_of_birth
Date

Missing

Distinct	6024
Distinct (%)	0.6%
Missing	639134
Missing (%)	37.7%
Memory size	12.9 MiB

Minimum	1978-01-28 00:00:00
Maximum	2008-09-21 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

sub_position
Categorical

High correlation Missing

Distinct	13
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Memory size	109.6 MiB

Centre-Back	190516
Centre-Forward	149256
Central Midfield	139159
Defensive Midfield	93685
Right-Back	88969
Other values (8)	395515

Length

Max length	18
Median length	14
Mean length	13.046192
Min length	9

Characters and Unicode

Total characters	13791130
Distinct characters	31
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Central Midfield
2nd row	Right-Back
3rd row	Centre-Back
4th row	Right-Back
5th row	Right Winger

Common Values

Value	Count	Frequency (%)
Centre-Back	190516	11.2%
Centre-Forward	149256	8.8%
Central Midfield	139159	8.2%
Defensive Midfield	93685	5.5%
Right-Back	88969	5.2%
Attacking Midfield	76323	4.5%
Right Winger	76199	4.5%
Goalkeeper	75434	4.4%
Left Winger	72740	4.3%
Left-Back	71798	4.2%
Other values (3)	23021	1.4%
(Missing)	639134	37.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
midfield	324232	21.1%
centre-back	190516	12.4%
centre-forward	149256	9.7%
winger	148939	9.7%
central	139159	9.0%
defensive	93685	6.1%
right-back	88969	5.8%
right	83412	5.4%
left	80592	5.2%
attacking	76323	5.0%
Other values (4)	163144	10.6%

Most occurring characters

Value	Count	Frequency (%)
e	1967533	14.3%
i	1147748	8.3%
r	1017728	7.4%
t	964304	7.0%
n	805834	5.8%
d	805676	5.8%
a	791455	5.7%
f	570307	4.1%
l	538825	3.9%
k	510996	3.7%
Other values (21)	4670724	33.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	13791130	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1967533	14.3%
i	1147748	8.3%
r	1017728	7.4%
t	964304	7.0%
n	805834	5.8%
d	805676	5.8%
a	791455	5.7%
f	570307	4.1%
l	538825	3.9%
k	510996	3.7%
Other values (21)	4670724	33.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	13791130	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1967533	14.3%
i	1147748	8.3%
r	1017728	7.4%
t	964304	7.0%
n	805834	5.8%
d	805676	5.8%
a	791455	5.7%
f	570307	4.1%
l	538825	3.9%
k	510996	3.7%
Other values (21)	4670724	33.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	13791130	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1967533	14.3%
i	1147748	8.3%
r	1017728	7.4%
t	964304	7.0%
n	805834	5.8%
d	805676	5.8%
a	791455	5.7%
f	570307	4.1%
l	538825	3.9%
k	510996	3.7%
Other values (21)	4670724	33.9%

position
Categorical

High correlation Missing

Distinct	4
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Memory size	104.1 MiB

Defender	351283
Midfield	324232
Attack	306151
Goalkeeper	75434

Length

Max length	10
Median length	8
Mean length	7.5634907
Min length	6

Characters and Unicode

Total characters	7995366
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Midfield
2nd row	Defender
3rd row	Defender
4th row	Defender
5th row	Attack

Common Values

Value	Count	Frequency (%)
Defender	351283	20.7%
Midfield	324232	19.1%
Attack	306151	18.0%
Goalkeeper	75434	4.4%
(Missing)	639134	37.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
defender	351283	33.2%
midfield	324232	30.7%
attack	306151	29.0%
goalkeeper	75434	7.1%

Most occurring characters

Value	Count	Frequency (%)
e	1604383	20.1%
d	999747	12.5%
f	675515	8.4%
i	648464	8.1%
t	612302	7.7%
r	426717	5.3%
l	399666	5.0%
k	381585	4.8%
a	381585	4.8%
D	351283	4.4%
Other values (7)	1514119	18.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7995366	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1604383	20.1%
d	999747	12.5%
f	675515	8.4%
i	648464	8.1%
t	612302	7.7%
r	426717	5.3%
l	399666	5.0%
k	381585	4.8%
a	381585	4.8%
D	351283	4.4%
Other values (7)	1514119	18.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7995366	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1604383	20.1%
d	999747	12.5%
f	675515	8.4%
i	648464	8.1%
t	612302	7.7%
r	426717	5.3%
l	399666	5.0%
k	381585	4.8%
a	381585	4.8%
D	351283	4.4%
Other values (7)	1514119	18.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7995366	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1604383	20.1%
d	999747	12.5%
f	675515	8.4%
i	648464	8.1%
t	612302	7.7%
r	426717	5.3%
l	399666	5.0%
k	381585	4.8%
a	381585	4.8%
D	351283	4.4%
Other values (7)	1514119	18.9%

foot
Categorical

Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Memory size	101.2 MiB

right	757776
left	261091
both	38233

Length

Max length	5
Median length	5
Mean length	4.7168442
Min length	4

Characters and Unicode

Total characters	4986176
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	right
2nd row	right
3rd row	right
4th row	right
5th row	left

Common Values

Value	Count	Frequency (%)
right	757776	44.7%
left	261091	15.4%
both	38233	2.3%
(Missing)	639134	37.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
right	757776	71.7%
left	261091	24.7%
both	38233	3.6%

Most occurring characters

Value	Count	Frequency (%)
t	1057100	21.2%
h	796009	16.0%
r	757776	15.2%
i	757776	15.2%
g	757776	15.2%
l	261091	5.2%
e	261091	5.2%
f	261091	5.2%
b	38233	0.8%
o	38233	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4986176	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	1057100	21.2%
h	796009	16.0%
r	757776	15.2%
i	757776	15.2%
g	757776	15.2%
l	261091	5.2%
e	261091	5.2%
f	261091	5.2%
b	38233	0.8%
o	38233	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4986176	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	1057100	21.2%
h	796009	16.0%
r	757776	15.2%
i	757776	15.2%
g	757776	15.2%
l	261091	5.2%
e	261091	5.2%
f	261091	5.2%
b	38233	0.8%
o	38233	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4986176	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	1057100	21.2%
h	796009	16.0%
r	757776	15.2%
i	757776	15.2%
g	757776	15.2%
l	261091	5.2%
e	261091	5.2%
f	261091	5.2%
b	38233	0.8%
o	38233	0.8%

height_in_cm
Real number (ℝ)

Missing

Distinct	51
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Infinite	0
Infinite (%)	0.0%
Mean	182.28081

Minimum	17
Maximum	207
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	17
5-th percentile	171
Q1	178
median	183
Q3	187
95-th percentile	193
Maximum	207
Range	190
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.7104383
Coefficient of variation (CV)	0.03681374
Kurtosis	4.6503543
Mean	182.28081
Median Absolute Deviation (MAD)	5
Skewness	-0.25926769
Sum	1.9268904 × 10⁸
Variance	45.029982
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
180	74830	4.4%
185	71475	4.2%
178	61950	3.7%
183	60991	3.6%
187	56227	3.3%
182	53867	3.2%
188	53805	3.2%
175	50293	3.0%
184	50068	3.0%
186	49407	2.9%
Other values (41)	474187	28.0%
(Missing)	639134	37.7%

Value	Count	Frequency (%)
17	5	< 0.1%
19	10	< 0.1%
159	114	< 0.1%
160	28	< 0.1%
161	113	< 0.1%
162	21	< 0.1%
163	1187	0.1%
164	520	< 0.1%
165	2150	0.1%
166	2058	0.1%

Value	Count	Frequency (%)
207	36	< 0.1%
206	137	< 0.1%
205	3	< 0.1%
204	7	< 0.1%
203	89	< 0.1%
202	290	< 0.1%
201	1649	0.1%
200	754	< 0.1%
199	1382	0.1%
198	3062	0.2%

contract_expiration_date
Date

Missing

Distinct	90
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Memory size	12.9 MiB

Minimum	2000-05-31 00:00:00
Maximum	2034-06-30 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

current_club_domestic_competition_id
Categorical

High correlation Missing

Distinct	14
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Memory size	99.5 MiB

ES1	115155
IT1	113087
TR1	110164
GB1	107354
L1	79028
Other values (9)	532312

Length

Max length	4
Median length	3
Mean length	2.9627717
Min length	2

Characters and Unicode

Total characters	3131946
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SC1
2nd row	TR1
3rd row	GB1
4th row	DK1
5th row	TR1

Common Values

Value	Count	Frequency (%)
ES1	115155	6.8%
IT1	113087	6.7%
TR1	110164	6.5%
GB1	107354	6.3%
L1	79028	4.7%
FR1	77763	4.6%
GR1	74131	4.4%
NL1	73550	4.3%
RU1	59972	3.5%
BE1	57996	3.4%
Other values (4)	188900	11.1%
(Missing)	639134	37.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
es1	115155	10.9%
it1	113087	10.7%
tr1	110164	10.4%
gb1	107354	10.2%
l1	79028	7.5%
fr1	77763	7.4%
gr1	74131	7.0%
nl1	73550	7.0%
ru1	59972	5.7%
be1	57996	5.5%
Other values (4)	188900	17.9%

Most occurring characters

Value	Count	Frequency (%)
1	1057100	33.8%
R	361704	11.5%
T	223251	7.1%
G	181485	5.8%
E	173151	5.5%
S	166724	5.3%
B	165350	5.3%
L	152578	4.9%
I	113087	3.6%
U	99646	3.2%
Other values (7)	437870	14.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3131946	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	1057100	33.8%
R	361704	11.5%
T	223251	7.1%
G	181485	5.8%
E	173151	5.5%
S	166724	5.3%
B	165350	5.3%
L	152578	4.9%
I	113087	3.6%
U	99646	3.2%
Other values (7)	437870	14.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3131946	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	1057100	33.8%
R	361704	11.5%
T	223251	7.1%
G	181485	5.8%
E	173151	5.5%
S	166724	5.3%
B	165350	5.3%
L	152578	4.9%
I	113087	3.6%
U	99646	3.2%
Other values (7)	437870	14.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3131946	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	1057100	33.8%
R	361704	11.5%
T	223251	7.1%
G	181485	5.8%
E	173151	5.5%
S	166724	5.3%
B	165350	5.3%
L	152578	4.9%
I	113087	3.6%
U	99646	3.2%
Other values (7)	437870	14.0%

current_club_name
Text

Missing

Distinct	436
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Memory size	115.7 MiB

Length

Max length	98
Median length	40
Mean length	24.152065
Min length	4

Characters and Unicode

Total characters	25531148
Distinct characters	111
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Saint Mirren Football Club
2nd row	Fatih Karagümrük
3rd row	Hull City
4th row	Fodbold Club Nordsjælland
5th row	Fenerbahçe Spor Kulübü

Value	Count	Frequency (%)
club	350397	9.8%
football	222762	6.2%
de	100050	2.8%
kulübü	66231	1.9%
s.a.d	62772	1.8%
fc	54474	1.5%
calcio	53171	1.5%
fk	40756	1.1%
fútbol	39493	1.1%
clube	37072	1.0%
Other values (772)	2540371	71.2%

Most occurring characters

Value	Count	Frequency (%)
	2510449	9.8%
l	1977389	7.7%
o	1886852	7.4%
a	1750431	6.9%
e	1695807	6.6%
i	1379690	5.4%
t	1282179	5.0%
n	1218303	4.8%
r	1081069	4.2%
b	1025004	4.0%
Other values (101)	9723975	38.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	25531148	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	2510449	9.8%
l	1977389	7.7%
o	1886852	7.4%
a	1750431	6.9%
e	1695807	6.6%
i	1379690	5.4%
t	1282179	5.0%
n	1218303	4.8%
r	1081069	4.2%
b	1025004	4.0%
Other values (101)	9723975	38.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	25531148	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	2510449	9.8%
l	1977389	7.7%
o	1886852	7.4%
a	1750431	6.9%
e	1695807	6.6%
i	1379690	5.4%
t	1282179	5.0%
n	1218303	4.8%
r	1081069	4.2%
b	1025004	4.0%
Other values (101)	9723975	38.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	25531148	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	2510449	9.8%
l	1977389	7.7%
o	1886852	7.4%
a	1750431	6.9%
e	1695807	6.6%
i	1379690	5.4%
t	1282179	5.0%
n	1218303	4.8%
r	1081069	4.2%
b	1025004	4.0%
Other values (101)	9723975	38.1%

market_value_in_eur
Real number (ℝ)

High correlation Missing

Distinct	122
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Infinite	0
Infinite (%)	0.0%
Mean	6121123.6

Minimum	10000
Maximum	2 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	10000
5-th percentile	100000
Q1	400000
median	1300000
Q3	5000000
95-th percentile	30000000
Maximum	2 × 10⁸
Range	1.9999 × 10⁸
Interquartile range (IQR)	4600000

Descriptive statistics

Standard deviation	13425977
Coefficient of variation (CV)	2.1933844
Kurtosis	41.533419
Mean	6121123.6
Median Absolute Deviation (MAD)	1100000
Skewness	5.2115042
Sum	6.4706398 × 10¹²
Variance	1.8025686 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300000	43079	2.5%
1500000	42349	2.5%
200000	40191	2.4%
1000000	39193	2.3%
500000	36400	2.1%
2000000	36343	2.1%
400000	35733	2.1%
3000000	33834	2.0%
100000	33616	2.0%
2500000	32336	1.9%
Other values (112)	684026	40.3%
(Missing)	639134	37.7%

Value	Count	Frequency (%)
10000	862	0.1%
20000	22	< 0.1%
25000	7712	0.5%
50000	16702	1.0%
75000	10887	0.6%
100000	33616	2.0%
125000	6030	0.4%
150000	26949	1.6%
175000	9548	0.6%
200000	40191	2.4%

Value	Count	Frequency (%)
200000000	229	< 0.1%
180000000	210	< 0.1%
160000000	365	< 0.1%
150000000	242	< 0.1%
140000000	675	< 0.1%
130000000	436	< 0.1%
110000000	618	< 0.1%
100000000	320	< 0.1%
90000000	488	< 0.1%
85000000	425	< 0.1%

highest_market_value_in_eur
Real number (ℝ)

High correlation Missing

Distinct	156
Distinct (%)	< 0.1%
Missing	639134
Missing (%)	37.7%
Infinite	0
Infinite (%)	0.0%
Mean	14123050

Minimum	10000
Maximum	2 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 MiB

Quantile statistics

Minimum	10000
5-th percentile	500000
Q1	1800000
median	5500000
Q3	18000000
95-th percentile	55000000
Maximum	2 × 10⁸
Range	1.9999 × 10⁸
Interquartile range (IQR)	16200000

Descriptive statistics

Standard deviation	21127385
Coefficient of variation (CV)	1.4959506
Kurtosis	13.286691
Mean	14123050
Median Absolute Deviation (MAD)	4600000
Skewness	3.0841609
Sum	1.4929476 × 10¹³
Variance	4.4636638 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000000	41241	2.4%
10000000	40977	2.4%
3000000	37812	2.2%
2000000	37094	2.2%
4000000	36100	2.1%
1500000	35633	2.1%
2500000	34781	2.1%
1000000	32937	1.9%
20000000	28661	1.7%
15000000	28157	1.7%
Other values (146)	703707	41.5%
(Missing)	639134	37.7%

Value	Count	Frequency (%)
10000	4	< 0.1%
25000	34	< 0.1%
50000	300	< 0.1%
75000	223	< 0.1%
100000	1044	0.1%
125000	282	< 0.1%
150000	1325	0.1%
175000	405	< 0.1%
200000	2522	0.1%
225000	748	< 0.1%

Value	Count	Frequency (%)
200000000	594	< 0.1%
180000000	210	< 0.1%
160000000	538	< 0.1%
150000000	2849	0.2%
140000000	388	< 0.1%
130000000	698	< 0.1%
120000000	878	0.1%
110000000	1433	0.1%
100000000	5083	0.3%
90000000	5390	0.3%

Interactions

Correlations

	Unnamed: 0	assists	competition_id	current_club_domestic_competition_id	current_club_id	foot	goals	height_in_cm	highest_market_value_in_eur	last_season	market_value_in_eur	minutes_played	player_club_id	player_current_club_id	player_id	position	sub_position
Unnamed: 0	1.000	-0.011	0.060	0.046	-0.044	0.031	-0.006	0.027	0.051	0.476	0.374	-0.111	0.014	-0.057	0.640	0.012	0.019
assists	-0.011	1.000	0.016	0.013	-0.035	0.016	0.072	-0.085	0.074	0.021	0.052	0.055	-0.035	-0.035	-0.009	0.065	0.071
competition_id	0.060	0.016	1.000	0.722	0.211	0.063	0.016	0.069	0.160	0.075	0.099	0.088	0.166	0.193	0.069	0.030	0.054
current_club_domestic_competition_id	0.046	0.013	0.722	1.000	0.246	0.066	0.011	0.084	0.160	0.069	0.133	0.023	0.178	0.246	0.070	0.042	0.062
current_club_id	-0.044	-0.035	0.211	0.246	1.000	0.026	-0.037	-0.053	-0.413	-0.176	-0.392	-0.023	0.596	1.000	-0.011	0.028	0.034
foot	0.031	0.016	0.063	0.066	0.026	1.000	0.012	0.037	0.042	0.049	0.038	0.024	0.022	0.026	0.045	0.116	0.367
goals	-0.006	0.072	0.016	0.011	-0.037	0.012	1.000	-0.026	0.094	0.019	0.068	0.050	-0.031	-0.036	-0.006	0.126	0.099
height_in_cm	0.027	-0.085	0.069	0.084	-0.053	0.037	-0.026	1.000	0.029	0.063	0.038	0.182	-0.048	-0.053	-0.030	0.218	0.290
highest_market_value_in_eur	0.051	0.074	0.160	0.160	-0.413	0.042	0.094	0.029	1.000	0.397	0.752	0.062	-0.405	-0.413	-0.032	0.078	0.075
last_season	0.476	0.021	0.075	0.069	-0.176	0.049	0.019	0.063	0.397	1.000	0.567	0.029	-0.126	-0.176	0.365	0.044	0.043
market_value_in_eur	0.374	0.052	0.099	0.133	-0.392	0.038	0.068	0.038	0.752	0.567	1.000	0.007	-0.300	-0.392	0.443	0.060	0.052
minutes_played	-0.111	0.055	0.088	0.023	-0.023	0.024	0.050	0.182	0.062	0.029	0.007	1.000	-0.003	-0.024	-0.162	0.244	0.147
player_club_id	0.014	-0.035	0.166	0.178	0.596	0.022	-0.031	-0.048	-0.405	-0.126	-0.300	-0.003	1.000	0.618	0.080	0.012	0.020
player_current_club_id	-0.057	-0.035	0.193	0.246	1.000	0.026	-0.036	-0.053	-0.413	-0.176	-0.392	-0.024	0.618	1.000	0.001	0.028	0.035
player_id	0.640	-0.009	0.069	0.070	-0.011	0.045	-0.006	-0.030	-0.032	0.365	0.443	-0.162	0.080	0.001	1.000	0.080	0.062
position	0.012	0.065	0.030	0.042	0.028	0.116	0.126	0.218	0.078	0.044	0.060	0.244	0.012	0.028	0.080	1.000	1.000
sub_position	0.019	0.071	0.054	0.062	0.034	0.367	0.099	0.290	0.075	0.043	0.052	0.147	0.020	0.035	0.062	1.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	Unnamed: 0	player_id	player_club_id	player_current_club_id	date	player_name	competition_id	goals	assists	minutes_played	first_name	last_name	name	last_season	current_club_id	country_of_citizenship	date_of_birth	sub_position	position	foot	height_in_cm	contract_expiration_date	current_club_domestic_competition_id	current_club_name	market_value_in_eur	highest_market_value_in_eur
0	0	38004	853	235	2012-07-03	Aurélien Joachim	CLQ	2	0	90	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	1	79232	8841	2698	2012-07-05	Ruslan Abyshov	ELQ	0	0	90	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	2	42792	6251	465	2012-07-05	Sander Puri	ELQ	0	0	45	Sander	Puri	Sander Puri	2012.0	465.0	Estonia	1988-05-07 00:00:00	Central Midfield	Midfield	right	177.0	2023-12-31 00:00:00	SC1	Saint Mirren Football Club	100000.0	600000.0
3	3	73333	1274	6646	2012-07-05	Vegar Hedenstad	ELQ	0	0	90	Vegar	Hedenstad	Vegar Hedenstad	2021.0	6646.0	Norway	1991-06-26 00:00:00	Right-Back	Defender	right	178.0	2024-12-31 00:00:00	TR1	Fatih Karagümrük	350000.0	1500000.0
4	4	122011	195	3008	2012-07-05	Markus Henriksen	ELQ	0	1	90	Markus	Henriksen	Markus Henriksen	2016.0	3008.0	Norway	1992-07-25 00:00:00	Centre-Back	Defender	right	187.0	2024-12-31 00:00:00	GB1	Hull City	800000.0	5000000.0
5	5	146889	195	2778	2012-07-05	Peter Ankersen	ELQ	0	0	90	Peter	Ankersen	Peter Ankersen	2024.0	2778.0	Denmark	1990-09-22 00:00:00	Right-Back	Defender	right	180.0	2026-06-30 00:00:00	DK1	Fodbold Club Nordsjælland	250000.0	3000000.0
6	6	28716	282	7185	2012-07-05	Adi Adilovic	ELQ	0	0	90	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
7	7	69445	282	19771	2012-07-05	Ivan Sesar	ELQ	0	1	90	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	8	19409	317	200	2012-07-05	Willem Janssen	ELQ	0	0	45	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
9	9	30003	317	317	2012-07-05	Wout Brama	ELQ	0	0	90	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

	Unnamed: 0	player_id	player_club_id	player_current_club_id	date	player_name	competition_id	goals	minutes_played	first_name	last_name	name	last_season	current_club_id	country_of_citizenship	date_of_birth	sub_position	position	foot	height_in_cm	contract_expiration_date	current_club_domestic_competition_id	current_club_name	market_value_in_eur	highest_market_value_in_eur
1696224	1696224	342151	2578	2578	2025-03-10	Daniels Balodis	SFA	0	90	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1696225	1696225	359199	2578	2578	2025-03-10	Andy Fisher	SFA	0	90	Andy	Fisher	Andy Fisher	2024.0	2578.0	England	1998-02-12 00:00:00	Goalkeeper	Goalkeeper	right	189.0	2025-05-31 00:00:00	SC1	Saint Johnstone Football Club	900000.0	1000000.0
1696226	1696226	430976	2578	2578	2025-03-10	Jonathan Svedberg	SFA	0	69	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1696227	1696227	503731	2578	2578	2025-03-10	Stephen Duke-McKenna	SFA	0	45	Stephen	Duke-McKenna	Stephen Duke-McKenna	2024.0	2578.0	Guyana	2000-08-17 00:00:00	Right Midfield	Midfield	right	170.0	2025-05-31 00:00:00	SC1	Saint Johnstone Football Club	150000.0	150000.0
1696228	1696228	700144	2578	2578	2025-03-10	Makenzie Kirk	SFA	0	90	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1696229	1696229	741267	2578	2578	2025-03-10	Sam Curtis	SFA	0	90	Sam	Curtis	Sam Curtis	2024.0	2578.0	Ireland	2005-12-01 00:00:00	Right-Back	Defender	right	185.0	2025-05-31 00:00:00	SC1	Saint Johnstone Football Club	175000.0	175000.0
1696230	1696230	796307	2578	2578	2025-03-10	Zach Mitchell	SFA	0	90	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1696231	1696231	80339	2578	2578	2025-03-10	Graham Carey	SFA	1	21	Graham	Carey	Graham Carey	2024.0	2578.0	Ireland	1989-05-20 00:00:00	Left Midfield	Midfield	left	183.0	2025-05-31 00:00:00	SC1	Saint Johnstone Football Club	150000.0	700000.0
1696232	1696232	909254	1241	43	2025-03-10	Macaulay Tait	SFA	0	90	Macaulay	Tait	Macaulay Tait	2024.0	43.0	Scotland	2005-08-27 00:00:00	Central Midfield	Midfield	left	170.0	2028-05-31 00:00:00	SC1	Heart of Midlothian Football Club	200000.0	200000.0
1696233	1696233	91854	2578	2578	2025-03-10	Barry Douglas	SFA	0	90	Barry	Douglas	Barry Douglas	2024.0	2578.0	Scotland	1989-09-04 00:00:00	Left-Back	Defender	left	176.0	2025-05-31 00:00:00	SC1	Saint Johnstone Football Club	100000.0	3500000.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters